🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-22 🟡

🔹 Automated Weekly VC Secondaries Newsletter Pipeline
👤 Client: 🇺🇸 United States Member since 2024-09-25
💰 Price: $100
🚩 Problem: Manual curation and drafting of a weekly newsletter is time-consuming.
📦 Existing: [Stack]

Specifications:

[Target] Daily ingestion of curated content from Twitter, TikTok, podcasts, YouTube, and Substack RSS feeds.
[Method] Automated ingestion using APIs and web scraping for specified sources.
[UI/UX] Not applicable
[Stack] Python (for automation), Hermes Agent (NLP for drafting), Beehiiv API (for publishing)
[Security] Secure handling of credentials and data privacy compliance.
[Format] JSON for structured data, Markdown for newsletter content

Workflow:

1. Set up daily ingestion scripts for Twitter, TikTok, podcast episodes, YouTube channels, and Substack RSS feeds.
2. Implement auto-transcription for audio/video content within one hour of publication using transcription APIs.
3. Create a knowledge base by pulling relevant content from the last 7 days and drafting sections in the client's voice with inline citations.
4. Schedule the Hermes agent to run Sunday at 8pm ET, generating the newsletter draft and sending it to the client’s inbox.
5. Develop visual generation scripts for creating at least three visuals per issue.
6. Integrate Beehiiv API for one-click publishing of the newsletter with a branded template.